USE [ANTS_NetServer]
GO

/****** Object:  StoredProcedure [dbo].[proc_userInfo_delete]    Script Date: 04/21/2013 15:27:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

--use ANTS_NetServer
create proc [dbo].[proc_userInfo_delete]
(
	@username varchar(20)
)
as 
delete from userInfo where username=@username
delete from NVRDeviceInfo where username=@username
GO

